SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}Port{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}' OR prCity = 'Port' OR prZip = 'Port' OR prStreet LIKE '{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}Port{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}' OR prCountry = 'Port') AND (prLocation LIKE '{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}de{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}' OR prCity = 'de' OR prZip = 'de' OR prStreet LIKE '{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}de{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}' OR prCountry = 'de') AND (prLocation LIKE '{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}Sóller{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}' OR prCity = 'Sóller' OR prZip = 'Sóller' OR prStreet LIKE '{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}Sóller{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}' OR prCountry = 'Sóller') AND (prLocation LIKE '{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}Spain{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}Spain{28a78a543c9b94d7ab9dcf06c3f929cbbf0f2850a028010fd88a95c886ebe001}' OR prCountry = 'Spain')